﻿CREATE TABLE [dbo].[ParamExUr] (
    [IdParam]  INT           NOT NULL,
    [IdCons]   INT           NOT NULL,
    [Denumire] VARCHAR (50)  NOT NULL,
    [Valoare]  VARCHAR (500) CONSTRAINT [DF_ParamExUr_Valoare] DEFAULT ('') NOT NULL,
    [Pozitie]  SMALLINT      CONSTRAINT [DF_ParamExUr_Pozitie] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ParamExUr] PRIMARY KEY CLUSTERED ([IdParam] ASC, [IdCons] ASC),
    CONSTRAINT [FK_ParamExUr_Consultatii] FOREIGN KEY ([IdCons]) REFERENCES [dbo].[Consultatii] ([IdCons]),
    CONSTRAINT [FK_ParamExUr_ParamExUrModel] FOREIGN KEY ([IdParam]) REFERENCES [dbo].[ParamExUrModel] ([IdParam])
);

